Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	10324
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	21
Duplicate rows (%)	0.2%
Total size in memory	1.5 MiB
Average record size in memory	153.0 B

Variable types

Text	4
Categorical	9
Numeric	6
Boolean	1

Alerts

Dataset has 21 (0.2%) duplicate rows	Duplicates
`brand` is highly overall correlated with `dosage` and 4 other fields	High correlation
`country` is highly overall correlated with `fulfill via` and 2 other fields	High correlation
`dosage` is highly overall correlated with `brand`	High correlation
`dosage form` is highly overall correlated with `brand` and 2 other fields	High correlation
`freight cost (usd)` is highly overall correlated with `weight`	High correlation
`fulfill via` is highly overall correlated with `brand` and 2 other fields	High correlation
`product group` is highly overall correlated with `brand` and 2 other fields	High correlation
`reliability` is highly overall correlated with `country` and 1 other fields	High correlation
`shipment mode` is highly overall correlated with `country` and 1 other fields	High correlation
`sub classification` is highly overall correlated with `brand` and 2 other fields	High correlation
`vendor inco term` is highly overall correlated with `fulfill via`	High correlation
`weight` is highly overall correlated with `freight cost (usd)`	High correlation
`managed by` is highly imbalanced (97.4%)	Imbalance
`product group` is highly imbalanced (69.9%)	Imbalance
`brand` is highly imbalanced (62.3%)	Imbalance
`weight` is highly skewed (γ1 = 44.78575407)	Skewed
`dosage` has 1736 (16.8%) zeros	Zeros
`Delivery Delay Risk` has 6324 (61.3%) zeros	Zeros

Reproduction

Analysis started	2025-01-14 18:00:28.031583
Analysis finished	2025-01-14 18:00:31.173498
Duration	3.14 seconds
Software version	ydata-profiling vv4.12.1
Download configuration	config.json

project code
Text

Distinct	142
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	103240
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	0.1%

Sample

1st row	100-CI-T01
2nd row	108-VN-T01
3rd row	100-CI-T01
4th row	108-VN-T01
5th row	108-VN-T01

Value	Count	Frequency (%)
116-za-t30	768	7.4%
104-ci-t30	729	7.1%
151-ng-t30	628	6.1%
114-ug-t30	596	5.8%
108-vn-t30	522	5.1%
106-ht-t30	450	4.4%
111-mz-t30	431	4.2%
110-zm-t30	406	3.9%
109-tz-t30	369	3.6%
107-rw-t30	340	3.3%
Other values (132)	5085	49.3%

Most occurring characters

Value	Count	Frequency (%)
-	20648	20.0%
1	18694	18.1%
0	16409	15.9%
T	11732	11.4%
3	8596	8.3%
Z	3815	3.7%
G	2289	2.2%
6	2032	2.0%
N	1981	1.9%
4	1852	1.8%
Other values (25)	15192	14.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	103240	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	20648	20.0%
1	18694	18.1%
0	16409	15.9%
T	11732	11.4%
3	8596	8.3%
Z	3815	3.7%
G	2289	2.2%
6	2032	2.0%
N	1981	1.9%
4	1852	1.8%
Other values (25)	15192	14.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	103240	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	20648	20.0%
1	18694	18.1%
0	16409	15.9%
T	11732	11.4%
3	8596	8.3%
Z	3815	3.7%
G	2289	2.2%
6	2032	2.0%
N	1981	1.9%
4	1852	1.8%
Other values (25)	15192	14.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	103240	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	20648	20.0%
1	18694	18.1%
0	16409	15.9%
T	11732	11.4%
3	8596	8.3%
Z	3815	3.7%
G	2289	2.2%
6	2032	2.0%
N	1981	1.9%
4	1852	1.8%
Other values (25)	15192	14.7%

country
Categorical

High correlation

Distinct	43
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

South Africa	1406
Nigeria	1194
Côte d'Ivoire	1083
Uganda	779
Vietnam	688
Other values (38)	5174

Length

Max length	18
Median length	12
Mean length	8.4762689
Min length	4

Characters and Unicode

Total characters	87509
Distinct characters	48
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Côte d'Ivoire
2nd row	Vietnam
3rd row	Côte d'Ivoire
4th row	Vietnam
5th row	Vietnam

Common Values

Value	Count	Frequency (%)
South Africa	1406	13.6%
Nigeria	1194	11.6%
Côte d'Ivoire	1083	10.5%
Uganda	779	7.5%
Vietnam	688	6.7%
Zambia	683	6.6%
Haiti	655	6.3%
Mozambique	631	6.1%
Zimbabwe	538	5.2%
Tanzania	519	5.0%
Other values (33)	2148	20.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
south	1570	11.7%
africa	1406	10.5%
nigeria	1194	8.9%
côte	1083	8.1%
d'ivoire	1083	8.1%
uganda	779	5.8%
vietnam	688	5.1%
zambia	683	5.1%
haiti	655	4.9%
mozambique	631	4.7%
Other values (38)	3596	26.9%

Most occurring characters

Value	Count	Frequency (%)
a	12282	14.0%
i	10247	11.7%
e	5522	6.3%
o	4473	5.1%
n	4350	5.0%
t	4323	4.9%
r	3874	4.4%
	3044	3.5%
u	2914	3.3%
m	2777	3.2%
Other values (38)	33703	38.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	87509	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	12282	14.0%
i	10247	11.7%
e	5522	6.3%
o	4473	5.1%
n	4350	5.0%
t	4323	4.9%
r	3874	4.4%
	3044	3.5%
u	2914	3.3%
m	2777	3.2%
Other values (38)	33703	38.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	87509	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	12282	14.0%
i	10247	11.7%
e	5522	6.3%
o	4473	5.1%
n	4350	5.0%
t	4323	4.9%
r	3874	4.4%
	3044	3.5%
u	2914	3.3%
m	2777	3.2%
Other values (38)	33703	38.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	87509	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	12282	14.0%
i	10247	11.7%
e	5522	6.3%
o	4473	5.1%
n	4350	5.0%
t	4323	4.9%
r	3874	4.4%
	3044	3.5%
u	2914	3.3%
m	2777	3.2%
Other values (38)	33703	38.5%

managed by
Categorical

Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

PMO - US	10265
South Africa Field Office	57
Haiti Field Office	1
Ethiopia Field Office	1

Length

Max length	25
Median length	8
Mean length	8.0960868
Min length	8

Characters and Unicode

Total characters	83584
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	PMO - US
2nd row	PMO - US
3rd row	PMO - US
4th row	PMO - US
5th row	PMO - US

Common Values

Value	Count	Frequency (%)
PMO - US	10265	99.4%
South Africa Field Office	57	0.6%
Haiti Field Office	1	< 0.1%
Ethiopia Field Office	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pmo	10265	33.1%
	10265	33.1%
us	10265	33.1%
office	59	0.2%
field	59	0.2%
africa	57	0.2%
south	57	0.2%
haiti	1	< 0.1%
ethiopia	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
	20705	24.8%
O	10324	12.4%
S	10322	12.3%
M	10265	12.3%
P	10265	12.3%
-	10265	12.3%
U	10265	12.3%
i	179	0.2%
f	175	0.2%
e	118	0.1%
Other values (14)	701	0.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	83584	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	20705	24.8%
O	10324	12.4%
S	10322	12.3%
M	10265	12.3%
P	10265	12.3%
-	10265	12.3%
U	10265	12.3%
i	179	0.2%
f	175	0.2%
e	118	0.1%
Other values (14)	701	0.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	83584	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	20705	24.8%
O	10324	12.4%
S	10322	12.3%
M	10265	12.3%
P	10265	12.3%
-	10265	12.3%
U	10265	12.3%
i	179	0.2%
f	175	0.2%
e	118	0.1%
Other values (14)	701	0.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	83584	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	20705	24.8%
O	10324	12.4%
S	10322	12.3%
M	10265	12.3%
P	10265	12.3%
-	10265	12.3%
U	10265	12.3%
i	179	0.2%
f	175	0.2%
e	118	0.1%
Other values (14)	701	0.8%

fulfill via
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

From RDC	5404
Direct Drop	4920

Length

Max length	11
Median length	8
Mean length	9.4296784
Min length	8

Characters and Unicode

Total characters	97352
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Direct Drop
2nd row	Direct Drop
3rd row	Direct Drop
4th row	Direct Drop
5th row	Direct Drop

Common Values

Value	Count	Frequency (%)
From RDC	5404	52.3%
Direct Drop	4920	47.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
from	5404	26.2%
rdc	5404	26.2%
direct	4920	23.8%
drop	4920	23.8%

Most occurring characters

Value	Count	Frequency (%)
r	15244	15.7%
D	15244	15.7%
	10324	10.6%
o	10324	10.6%
F	5404	5.6%
m	5404	5.6%
R	5404	5.6%
C	5404	5.6%
i	4920	5.1%
e	4920	5.1%
Other values (3)	14760	15.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	97352	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	15244	15.7%
D	15244	15.7%
	10324	10.6%
o	10324	10.6%
F	5404	5.6%
m	5404	5.6%
R	5404	5.6%
C	5404	5.6%
i	4920	5.1%
e	4920	5.1%
Other values (3)	14760	15.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	97352	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	15244	15.7%
D	15244	15.7%
	10324	10.6%
o	10324	10.6%
F	5404	5.6%
m	5404	5.6%
R	5404	5.6%
C	5404	5.6%
i	4920	5.1%
e	4920	5.1%
Other values (3)	14760	15.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	97352	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	15244	15.7%
D	15244	15.7%
	10324	10.6%
o	10324	10.6%
F	5404	5.6%
m	5404	5.6%
R	5404	5.6%
C	5404	5.6%
i	4920	5.1%
e	4920	5.1%
Other values (3)	14760	15.2%

vendor inco term
Categorical

High correlation

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

N/A - From RDC	5404
EXW	2778
DDP	1443
FCA	397
CIP	275
Other values (3)	27

Length

Max length	14
Median length	14
Mean length	8.7578458
Min length	3

Characters and Unicode

Total characters	90416
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	EXW
2nd row	EXW
3rd row	FCA
4th row	EXW
5th row	EXW

Common Values

Value	Count	Frequency (%)
N/A - From RDC	5404	52.3%
EXW	2778	26.9%
DDP	1443	14.0%
FCA	397	3.8%
CIP	275	2.7%
DDU	15	0.1%
DAP	9	0.1%
CIF	3	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n/a	5404	20.4%
	5404	20.4%
from	5404	20.4%
rdc	5404	20.4%
exw	2778	10.5%
ddp	1443	5.4%
fca	397	1.5%
cip	275	1.0%
ddu	15	0.1%
dap	9	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
	16212	17.9%
D	8329	9.2%
C	6079	6.7%
A	5810	6.4%
F	5804	6.4%
N	5404	6.0%
/	5404	6.0%
o	5404	6.0%
r	5404	6.0%
-	5404	6.0%
Other values (8)	21162	23.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	90416	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	16212	17.9%
D	8329	9.2%
C	6079	6.7%
A	5810	6.4%
F	5804	6.4%
N	5404	6.0%
/	5404	6.0%
o	5404	6.0%
r	5404	6.0%
-	5404	6.0%
Other values (8)	21162	23.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	90416	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	16212	17.9%
D	8329	9.2%
C	6079	6.7%
A	5810	6.4%
F	5804	6.4%
N	5404	6.0%
/	5404	6.0%
o	5404	6.0%
r	5404	6.0%
-	5404	6.0%
Other values (8)	21162	23.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	90416	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	16212	17.9%
D	8329	9.2%
C	6079	6.7%
A	5810	6.4%
F	5804	6.4%
N	5404	6.0%
/	5404	6.0%
o	5404	6.0%
r	5404	6.0%
-	5404	6.0%
Other values (8)	21162	23.4%

shipment mode
Categorical

High correlation

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Air	6473
Truck	2830
Air Charter	650
Ocean	371

Length

Max length	11
Median length	3
Mean length	4.1237892
Min length	3

Characters and Unicode

Total characters	42574
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Air
2nd row	Air
3rd row	Air
4th row	Air
5th row	Air

Common Values

Value	Count	Frequency (%)
Air	6473	62.7%
Truck	2830	27.4%
Air Charter	650	6.3%
Ocean	371	3.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
air	7123	64.9%
truck	2830	25.8%
charter	650	5.9%
ocean	371	3.4%

Most occurring characters

Value	Count	Frequency (%)
r	11253	26.4%
A	7123	16.7%
i	7123	16.7%
c	3201	7.5%
T	2830	6.6%
u	2830	6.6%
k	2830	6.6%
a	1021	2.4%
e	1021	2.4%
C	650	1.5%
Other values (5)	2692	6.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	42574	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	11253	26.4%
A	7123	16.7%
i	7123	16.7%
c	3201	7.5%
T	2830	6.6%
u	2830	6.6%
k	2830	6.6%
a	1021	2.4%
e	1021	2.4%
C	650	1.5%
Other values (5)	2692	6.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	42574	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	11253	26.4%
A	7123	16.7%
i	7123	16.7%
c	3201	7.5%
T	2830	6.6%
u	2830	6.6%
k	2830	6.6%
a	1021	2.4%
e	1021	2.4%
C	650	1.5%
Other values (5)	2692	6.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	42574	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	11253	26.4%
A	7123	16.7%
i	7123	16.7%
c	3201	7.5%
T	2830	6.6%
u	2830	6.6%
k	2830	6.6%
a	1021	2.4%
e	1021	2.4%
C	650	1.5%
Other values (5)	2692	6.3%

product group
Categorical

High correlation Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

ARV	8550
HRDT	1728
ANTM	22
ACT	16
MRDT	8

Length

Max length	4
Median length	3
Mean length	3.1702828
Min length	3

Characters and Unicode

Total characters	32730
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	HRDT
2nd row	ARV
3rd row	HRDT
4th row	ARV
5th row	ARV

Common Values

Value	Count	Frequency (%)
ARV	8550	82.8%
HRDT	1728	16.7%
ANTM	22	0.2%
ACT	16	0.2%
MRDT	8	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
arv	8550	82.8%
hrdt	1728	16.7%
antm	22	0.2%
act	16	0.2%
mrdt	8	0.1%

Most occurring characters

Value	Count	Frequency (%)
R	10286	31.4%
A	8588	26.2%
V	8550	26.1%
T	1774	5.4%
D	1736	5.3%
H	1728	5.3%
M	30	0.1%
N	22	0.1%
C	16	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	32730	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
R	10286	31.4%
A	8588	26.2%
V	8550	26.1%
T	1774	5.4%
D	1736	5.3%
H	1728	5.3%
M	30	0.1%
N	22	0.1%
C	16	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	32730	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
R	10286	31.4%
A	8588	26.2%
V	8550	26.1%
T	1774	5.4%
D	1736	5.3%
H	1728	5.3%
M	30	0.1%
N	22	0.1%
C	16	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	32730	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
R	10286	31.4%
A	8588	26.2%
V	8550	26.1%
T	1774	5.4%
D	1736	5.3%
H	1728	5.3%
M	30	0.1%
N	22	0.1%
C	16	< 0.1%

sub classification
Categorical

High correlation

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Adult	6595
Pediatric	1955
HIV test	1567
HIV test - Ancillary	161
Malaria	30

Length

Max length	20
Median length	5
Mean length	6.4494382
Min length	3

Characters and Unicode

Total characters	66584
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	HIV test
2nd row	Pediatric
3rd row	HIV test
4th row	Adult
5th row	Adult

Common Values

Value	Count	Frequency (%)
Adult	6595	63.9%
Pediatric	1955	18.9%
HIV test	1567	15.2%
HIV test - Ancillary	161	1.6%
Malaria	30	0.3%
ACT	16	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
adult	6595	53.3%
pediatric	1955	15.8%
hiv	1728	14.0%
test	1728	14.0%
	161	1.3%
ancillary	161	1.3%
malaria	30	0.2%
act	16	0.1%

Most occurring characters

Value	Count	Frequency (%)
t	12006	18.0%
d	8550	12.8%
l	6947	10.4%
A	6772	10.2%
u	6595	9.9%
i	4101	6.2%
e	3683	5.5%
a	2206	3.3%
r	2146	3.2%
c	2116	3.2%
Other values (12)	11462	17.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	66584	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	12006	18.0%
d	8550	12.8%
l	6947	10.4%
A	6772	10.2%
u	6595	9.9%
i	4101	6.2%
e	3683	5.5%
a	2206	3.3%
r	2146	3.2%
c	2116	3.2%
Other values (12)	11462	17.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	66584	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	12006	18.0%
d	8550	12.8%
l	6947	10.4%
A	6772	10.2%
u	6595	9.9%
i	4101	6.2%
e	3683	5.5%
a	2206	3.3%
r	2146	3.2%
c	2116	3.2%
Other values (12)	11462	17.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	66584	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	12006	18.0%
d	8550	12.8%
l	6947	10.4%
A	6772	10.2%
u	6595	9.9%
i	4101	6.2%
e	3683	5.5%
a	2206	3.3%
r	2146	3.2%
c	2116	3.2%
Other values (12)	11462	17.2%

vendor
Text

Distinct	73
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Length

Max length	65
Median length	13
Mean length	18.53332
Min length	7

Characters and Unicode

Total characters	191338
Distinct characters	54
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19 ?
Unique (%)	0.2%

Sample

1st row	RANBAXY Fine Chemicals LTD.
2nd row	Aurobindo Pharma Limited
3rd row	Abbott GmbH & Co. KG
4th row	SUN PHARMACEUTICAL INDUSTRIES LTD (RANBAXY LABORATORIES LIMITED)
5th row	Aurobindo Pharma Limited

Value	Count	Frequency (%)
scms	5404	16.5%
from	5404	16.5%
rdc	5404	16.5%
limited	1288	3.9%
ltd	1169	3.6%
orgenics	754	2.3%
s	717	2.2%
buys	715	2.2%
wholesaler	715	2.2%
laboratories	705	2.2%
Other values (158)	10470	32.0%

Most occurring characters

Value	Count	Frequency (%)
	22491	11.8%
S	16965	8.9%
C	13420	7.0%
R	11481	6.0%
M	8653	4.5%
r	8112	4.2%
D	7485	3.9%
o	7434	3.9%
L	7380	3.9%
m	6798	3.6%
Other values (44)	81119	42.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	191338	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	22491	11.8%
S	16965	8.9%
C	13420	7.0%
R	11481	6.0%
M	8653	4.5%
r	8112	4.2%
D	7485	3.9%
o	7434	3.9%
L	7380	3.9%
m	6798	3.6%
Other values (44)	81119	42.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	191338	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	22491	11.8%
S	16965	8.9%
C	13420	7.0%
R	11481	6.0%
M	8653	4.5%
r	8112	4.2%
D	7485	3.9%
o	7434	3.9%
L	7380	3.9%
m	6798	3.6%
Other values (44)	81119	42.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	191338	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	22491	11.8%
S	16965	8.9%
C	13420	7.0%
R	11481	6.0%
M	8653	4.5%
r	8112	4.2%
D	7485	3.9%
o	7434	3.9%
L	7380	3.9%
m	6798	3.6%
Other values (44)	81119	42.4%

molecule/test type
Text

Distinct	86
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Length

Max length	98
Median length	60
Mean length	22.15091
Min length	7

Characters and Unicode

Total characters	228686
Distinct characters	63
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14 ?
Unique (%)	0.1%

Sample

1st row	HIV, Reveal G3 Rapid HIV-1 Antibody Test
2nd row	Nevirapine
3rd row	HIV 1/2, Determine Complete HIV Kit
4th row	Lamivudine
5th row	Stavudine

Value	Count	Frequency (%)
hiv	3055	13.6%
kit	1579	7.0%
1/2	1524	6.8%
disoproxil	1300	5.8%
fumarate	1300	5.8%
efavirenz	1125	5.0%
nevirapine	877	3.9%
determine	799	3.6%
lamivudine/nevirapine/zidovudine	707	3.2%
lamivudine/zidovudine	689	3.1%
Other values (148)	9451	42.2%

Most occurring characters

Value	Count	Frequency (%)
i	30297	13.2%
e	19499	8.5%
a	15535	6.8%
n	15469	6.8%
v	13084	5.7%
	12082	5.3%
r	11537	5.0%
o	10997	4.8%
d	9170	4.0%
t	8291	3.6%
Other values (53)	82725	36.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	228686	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	30297	13.2%
e	19499	8.5%
a	15535	6.8%
n	15469	6.8%
v	13084	5.7%
	12082	5.3%
r	11537	5.0%
o	10997	4.8%
d	9170	4.0%
t	8291	3.6%
Other values (53)	82725	36.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	228686	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	30297	13.2%
e	19499	8.5%
a	15535	6.8%
n	15469	6.8%
v	13084	5.7%
	12082	5.3%
r	11537	5.0%
o	10997	4.8%
d	9170	4.0%
t	8291	3.6%
Other values (53)	82725	36.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	228686	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	30297	13.2%
e	19499	8.5%
a	15535	6.8%
n	15469	6.8%
v	13084	5.7%
	12082	5.3%
r	11537	5.0%
o	10997	4.8%
d	9170	4.0%
t	8291	3.6%
Other values (53)	82725	36.2%

brand
Categorical

High correlation Imbalance

Distinct	48
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Generic	7285
Determine	799
Uni-Gold	373
Aluvia	250
Kaletra	165
Other values (43)	1452

Length

Max length	15
Median length	7
Mean length	7.2879698
Min length	3

Characters and Unicode

Total characters	75241
Distinct characters	48
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	Reveal
2nd row	Generic
3rd row	Determine
4th row	Generic
5th row	Generic

Common Values

Value	Count	Frequency (%)
Generic	7285	70.6%
Determine	799	7.7%
Uni-Gold	373	3.6%
Aluvia	250	2.4%
Kaletra	165	1.6%
Norvir	136	1.3%
Stat-Pak	115	1.1%
Bioline	113	1.1%
Truvada	94	0.9%
Videx	84	0.8%
Other values (38)	910	8.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
generic	7285	69.7%
determine	799	7.6%
uni-gold	373	3.6%
aluvia	250	2.4%
kaletra	165	1.6%
norvir	136	1.3%
videx	125	1.2%
stat-pak	115	1.1%
bioline	113	1.1%
truvada	94	0.9%
Other values (40)	995	9.5%

Most occurring characters

Value	Count	Frequency (%)
e	18044	24.0%
i	10118	13.4%
r	9288	12.3%
n	8958	11.9%
G	7758	10.3%
c	7463	9.9%
t	1628	2.2%
a	1599	2.1%
l	1331	1.8%
o	991	1.3%
Other values (38)	8063	10.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	75241	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	18044	24.0%
i	10118	13.4%
r	9288	12.3%
n	8958	11.9%
G	7758	10.3%
c	7463	9.9%
t	1628	2.2%
a	1599	2.1%
l	1331	1.8%
o	991	1.3%
Other values (38)	8063	10.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	75241	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	18044	24.0%
i	10118	13.4%
r	9288	12.3%
n	8958	11.9%
G	7758	10.3%
c	7463	9.9%
t	1628	2.2%
a	1599	2.1%
l	1331	1.8%
o	991	1.3%
Other values (38)	8063	10.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	75241	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	18044	24.0%
i	10118	13.4%
r	9288	12.3%
n	8958	11.9%
G	7758	10.3%
c	7463	9.9%
t	1628	2.2%
a	1599	2.1%
l	1331	1.8%
o	991	1.3%
Other values (38)	8063	10.7%

dosage
Real number (ℝ)

High correlation Zeros

Distinct	22
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	191.49671

Minimum	0
Maximum	600
Zeros	1736
Zeros (%)	16.8%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	20
median	150
Q3	300
95-th percentile	600
Maximum	600
Range	600
Interquartile range (IQR)	280

Descriptive statistics

Standard deviation	185.29451
Coefficient of variation (CV)	0.967612
Kurtosis	0.25207311
Mean	191.49671
Median Absolute Deviation (MAD)	140
Skewness	1.0582551
Sum	1977012
Variance	34334.056
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
150	2015	19.5%
0	1736	16.8%
200	1487	14.4%
300	1467	14.2%
600	1262	12.2%
10	552	5.3%
30	426	4.1%
100	301	2.9%
20	207	2.0%
50	179	1.7%
Other values (12)	692	6.7%

Value	Count	Frequency (%)
0	1736	16.8%
1	54	0.5%
2	11	0.1%
10	552	5.3%
15	38	0.4%
20	207	2.0%
25	39	0.4%
30	426	4.1%
40	6	0.1%
50	179	1.7%

Value	Count	Frequency (%)
600	1262	12.2%
500	23	0.2%
400	156	1.5%
300	1467	14.2%
250	88	0.9%
200	1487	14.4%
150	2015	19.5%
133	7	0.1%
125	4	< 0.1%
100	301	2.9%

dosage form
Categorical

High correlation

Distinct	17
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Tablet	3532
Tablet - FDC	2749
Test kit	1575
Capsule	729
Oral solution	727
Other values (12)	1012

Length

Max length	34
Median length	33
Mean length	10.253584
Min length	6

Characters and Unicode

Total characters	105858
Distinct characters	32
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Test kit
2nd row	Oral suspension
3rd row	Test kit
4th row	Tablet
5th row	Capsule

Common Values

Value	Count	Frequency (%)
Tablet	3532	34.2%
Tablet - FDC	2749	26.6%
Test kit	1575	15.3%
Capsule	729	7.1%
Oral solution	727	7.0%
Chewable/dispersible tablet - FDC	239	2.3%
Oral suspension	214	2.1%
Test kit - Ancillary	161	1.6%
Chewable/dispersible tablet	146	1.4%
Delayed-release capsules	131	1.3%
Other values (7)	121	1.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
tablet	6711	33.3%
	3270	16.2%
fdc	3023	15.0%
test	1736	8.6%
kit	1736	8.6%
oral	970	4.8%
solution	755	3.7%
capsule	729	3.6%
chewable/dispersible	385	1.9%
suspension	214	1.1%
Other values (8)	654	3.2%

Most occurring characters

Value	Count	Frequency (%)
e	12083	11.4%
t	11415	10.8%
l	10859	10.3%
	9859	9.3%
a	9472	8.9%
T	8062	7.6%
b	7567	7.1%
s	5234	4.9%
C	4137	3.9%
i	3728	3.5%
Other values (22)	23442	22.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	105858	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	12083	11.4%
t	11415	10.8%
l	10859	10.3%
	9859	9.3%
a	9472	8.9%
T	8062	7.6%
b	7567	7.1%
s	5234	4.9%
C	4137	3.9%
i	3728	3.5%
Other values (22)	23442	22.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	105858	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	12083	11.4%
t	11415	10.8%
l	10859	10.3%
	9859	9.3%
a	9472	8.9%
T	8062	7.6%
b	7567	7.1%
s	5234	4.9%
C	4137	3.9%
i	3728	3.5%
Other values (22)	23442	22.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	105858	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	12083	11.4%
t	11415	10.8%
l	10859	10.3%
	9859	9.3%
a	9472	8.9%
T	8062	7.6%
b	7567	7.1%
s	5234	4.9%
C	4137	3.9%
i	3728	3.5%
Other values (22)	23442	22.1%

manufacturing site
Text

Distinct	88
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Length

Max length	72
Median length	37
Mean length	25.039132
Min length	5

Characters and Unicode

Total characters	258504
Distinct characters	69
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16 ?
Unique (%)	0.2%

Sample

1st row	Ranbaxy Fine Chemicals LTD
2nd row	Aurobindo Unit III, India
3rd row	ABBVIE GmbH & Co.KG Wiesbaden
4th row	Ranbaxy, Paonta Shahib, India
5th row	Aurobindo Unit III, India

Value	Count	Frequency (%)
india	4678	11.9%
unit	4197	10.7%
iii	4041	10.3%
aurobindo	3283	8.4%
mylan	1438	3.7%
formerly	1415	3.6%
matrix	1415	3.6%
nashik	1415	3.6%
in	1047	2.7%
hetero	913	2.3%
Other values (201)	15396	39.2%

Most occurring characters

Value	Count	Frequency (%)
	28937	11.2%
i	20789	8.0%
I	19607	7.6%
a	18921	7.3%
n	18236	7.1%
r	13636	5.3%
o	12958	5.0%
d	12314	4.8%
e	10570	4.1%
t	10195	3.9%
Other values (59)	92341	35.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	258504	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	28937	11.2%
i	20789	8.0%
I	19607	7.6%
a	18921	7.3%
n	18236	7.1%
r	13636	5.3%
o	12958	5.0%
d	12314	4.8%
e	10570	4.1%
t	10195	3.9%
Other values (59)	92341	35.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	258504	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	28937	11.2%
i	20789	8.0%
I	19607	7.6%
a	18921	7.3%
n	18236	7.1%
r	13636	5.3%
o	12958	5.0%
d	12314	4.8%
e	10570	4.1%
t	10195	3.9%
Other values (59)	92341	35.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	258504	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	28937	11.2%
i	20789	8.0%
I	19607	7.6%
a	18921	7.3%
n	18236	7.1%
r	13636	5.3%
o	12958	5.0%
d	12314	4.8%
e	10570	4.1%
t	10195	3.9%
Other values (59)	92341	35.7%

first line designation
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.2 KiB

True	7030
False	3294

Value	Count	Frequency (%)
True	7030	68.1%
False	3294	31.9%

freight cost (usd)
Real number (ℝ)

High correlation

Distinct	9529
Distinct (%)	92.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11015.454

Minimum	0.75
Maximum	289653.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	0.75
5-th percentile	787.7315
Q1	2687.8435
median	6397.5225
Q3	14032.869
95-th percentile	34721.667
Maximum	289653.2
Range	289652.45
Interquartile range (IQR)	11345.025

Descriptive statistics

Standard deviation	14652.048
Coefficient of variation (CV)	1.3301357
Kurtosis	43.027716
Mean	11015.454
Median Absolute Deviation (MAD)	4569.887
Skewness	4.7521843
Sum	1.1372354 × 10⁸
Variance	2.1468252 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9736.1	40	0.4%
6147.18	31	0.3%
13398.06	17	0.2%
7445.8	16	0.2%
9341.49	15	0.1%
25231.96	12	0.1%
7329.83	12	0.1%
1211.48	11	0.1%
11637.64	11	0.1%
15128.37	11	0.1%
Other values (9519)	10148	98.3%

Value	Count	Frequency (%)
0.75	1	< 0.1%
14.36	1	< 0.1%
17.72	1	< 0.1%
22.29	1	< 0.1%
29.21	1	< 0.1%
30	1	< 0.1%
30.49	1	< 0.1%
41	1	< 0.1%
42.35	1	< 0.1%
48	1	< 0.1%

Value	Count	Frequency (%)
289653.2	1	< 0.1%
241407.27	1	< 0.1%
220076.52	1	< 0.1%
194623.44	1	< 0.1%
184243.3725	1	< 0.1%
161962.32	1	< 0.1%
161712.87	1	< 0.1%
152368.7	1	< 0.1%
150499.84	1	< 0.1%
146850.66	1	< 0.1%

reliability
Real number (ℝ)

High correlation

Distinct	67
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	366.08485

Minimum	1
Maximum	768
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	1
5-th percentile	17
Q1	145
median	340
Q3	596
95-th percentile	768
Maximum	768
Range	767
Interquartile range (IQR)	451

Descriptive statistics

Standard deviation	238.18725
Coefficient of variation (CV)	0.65063401
Kurtosis	-1.1198953
Mean	366.08485
Median Absolute Deviation (MAD)	201
Skewness	0.18250127
Sum	3779460
Variance	56733.168
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
768	768	7.4%
729	729	7.1%
628	628	6.1%
596	596	5.8%
522	522	5.1%
450	450	4.4%
431	431	4.2%
406	406	3.9%
369	369	3.6%
340	340	3.3%
Other values (57)	5085	49.3%

Value	Count	Frequency (%)
1	12	0.1%
2	20	0.2%
3	39	0.4%
4	24	0.2%
5	30	0.3%
6	18	0.2%
7	21	0.2%
8	48	0.5%
9	18	0.2%
10	80	0.8%

Value	Count	Frequency (%)
768	768	7.4%
729	729	7.1%
628	628	6.1%
596	596	5.8%
522	522	5.1%
450	450	4.4%
431	431	4.2%
406	406	3.9%
369	369	3.6%
340	340	3.3%

Delivery Delay Risk
Real number (ℝ)

Zeros

Distinct	76
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.15689395

Minimum	-1
Maximum	1
Zeros	6324
Zeros (%)	61.3%
Negative	2814
Negative (%)	27.3%
Memory size	80.8 KiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	-0.90514825
median	0
Q3	0
95-th percentile	0.99999834
Maximum	1
Range	2
Interquartile range (IQR)	0.90514825

Descriptive statistics

Standard deviation	0.5833083
Coefficient of variation (CV)	-3.7178509
Kurtosis	-0.32082862
Mean	-0.15689395
Median Absolute Deviation (MAD)	0
Skewness	0.044119761
Sum	-1619.7731
Variance	0.34024858
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6324	61.3%
-1	698	6.8%
1	188	1.8%
-0.9999999172	127	1.2%
-0.9950547537	119	1.2%
-0.9993292997	112	1.1%
-0.9999954794	107	1.0%
-0.9981778976	106	1.0%
-0.761594156	93	0.9%
0.4621171573	92	0.9%
Other values (66)	2358	22.8%

Value	Count	Frequency (%)
-1	698	6.8%
-1	11	0.1%
-1	25	0.2%
-1	22	0.2%
-1	32	0.3%
-1	12	0.1%
-1	26	0.3%
-1	77	0.7%
-1	14	0.1%
-1	28	0.3%

Value	Count	Frequency (%)
1	188	1.8%
1	4	< 0.1%
1	9	0.1%
1	10	0.1%
1	3	< 0.1%
1	6	0.1%
1	10	0.1%
1	13	0.1%
1	8	0.1%
1	7	0.1%

weight
Real number (ℝ)

High correlation Skewed

Distinct	6450
Distinct (%)	62.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3376.4822

Minimum	0
Maximum	857354
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	0
5-th percentile	30
Q1	314.75
median	1221
Q3	3381.25
95-th percentile	12358.05
Maximum	857354
Range	857354
Interquartile range (IQR)	3066.5

Descriptive statistics

Standard deviation	11365.3
Coefficient of variation (CV)	3.3660181
Kurtosis	3148.0062
Mean	3376.4822
Median Absolute Deviation (MAD)	1085.4615
Skewness	44.785754
Sum	34858802
Variance	1.2917005 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	29	0.3%
6	27	0.3%
1	23	0.2%
60	21	0.2%
12	20	0.2%
5	20	0.2%
4	19	0.2%
21	19	0.2%
17	19	0.2%
14	19	0.2%
Other values (6440)	10108	97.9%

Value	Count	Frequency (%)
0	1	< 0.1%
1	23	0.2%
2	29	0.3%
3	18	0.2%
4	19	0.2%
4.5	1	< 0.1%
5	20	0.2%
6	27	0.3%
7	16	0.2%
7.5	2	< 0.1%

Value	Count	Frequency (%)
857354	1	< 0.1%
291096	1	< 0.1%
205503	1	< 0.1%
154780	1	< 0.1%
145719.5	1	< 0.1%
112027	1	< 0.1%
102929	1	< 0.1%
90446	1	< 0.1%
88761	1	< 0.1%
88190	1	< 0.1%

profit
Real number (ℝ)

Distinct	9371
Distinct (%)	90.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0052752 × 10⁸

Minimum	0
Maximum	4.1696609 × 10¹⁰
Zeros	54
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	0
5-th percentile	51.52
Q1	31884.054
median	1436794.2
Q3	39453344
95-th percentile	7.2467663 × 10⁸
Maximum	4.1696609 × 10¹⁰
Range	4.1696609 × 10¹⁰
Interquartile range (IQR)	39421459

Descriptive statistics

Standard deviation	1.210646 × 10⁹
Coefficient of variation (CV)	6.0373058
Kurtosis	365.12567
Mean	2.0052752 × 10⁸
Median Absolute Deviation (MAD)	1436744.4
Skewness	16.21943
Sum	2.0702462 × 10¹²
Variance	1.4656637 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	54	0.5%
83617116.24	15	0.1%
66000000	13	0.1%
16384	12	0.1%
501760	10	0.1%
64000000	10	0.1%
853820.352	9	0.1%
576960400	8	0.1%
121506969.9	8	0.1%
122.5	7	0.1%
Other values (9361)	10178	98.6%

Value	Count	Frequency (%)
0	54	0.5%
0.0276	1	< 0.1%
0.0374	1	< 0.1%
0.0405	1	< 0.1%
0.0442	1	< 0.1%
0.045	1	< 0.1%
0.0477	1	< 0.1%
0.0497	1	< 0.1%
0.0506	1	< 0.1%
0.055	1	< 0.1%

Value	Count	Frequency (%)
4.169660923 × 10¹⁰	1	< 0.1%
3.420964588 × 10¹⁰	1	< 0.1%
3.031636951 × 10¹⁰	1	< 0.1%
2.920316677 × 10¹⁰	1	< 0.1%
2.716057189 × 10¹⁰	1	< 0.1%
2.528271154 × 10¹⁰	1	< 0.1%
2.211915863 × 10¹⁰	1	< 0.1%
1.993079448 × 10¹⁰	1	< 0.1%
1.882138799 × 10¹⁰	1	< 0.1%
1.804335738 × 10¹⁰	1	< 0.1%

	Delivery Delay Risk	brand	country	dosage	dosage form	first line designation	freight cost (usd)	fulfill via	managed by	product group	profit	reliability	shipment mode	sub classification	vendor inco term	weight
Delivery Delay Risk	1.000	0.133	0.150	-0.098	0.135	0.076	-0.019	0.497	0.024	0.125	0.008	-0.119	0.218	0.113	0.209	-0.016
brand	0.133	1.000	0.199	0.543	0.515	0.245	0.047	0.507	0.163	0.781	0.000	0.189	0.210	0.647	0.443	0.000
country	0.150	0.199	1.000	0.175	0.194	0.321	0.051	0.610	0.098	0.313	0.000	0.726	0.535	0.310	0.441	0.000
dosage	-0.098	0.543	0.175	1.000	0.461	0.134	0.044	0.377	0.000	0.435	0.211	0.242	0.175	0.467	0.278	0.186
dosage form	0.135	0.515	0.194	0.461	1.000	0.230	0.025	0.476	0.019	0.653	0.032	0.180	0.235	0.825	0.288	0.000
first line designation	0.076	0.245	0.321	0.134	0.230	1.000	0.029	0.099	0.099	0.192	0.027	0.222	0.233	0.207	0.309	0.000
freight cost (usd)	-0.019	0.047	0.051	0.044	0.025	0.029	1.000	0.024	0.000	0.000	0.359	0.117	0.038	0.033	0.019	0.706
fulfill via	0.497	0.507	0.610	0.377	0.476	0.099	0.024	1.000	0.078	0.385	0.064	0.402	0.361	0.394	1.000	0.000
managed by	0.024	0.163	0.098	0.000	0.019	0.099	0.000	0.078	1.000	0.018	0.000	0.103	0.069	0.018	0.105	0.000
product group	0.125	0.781	0.313	0.435	0.653	0.192	0.000	0.385	0.018	1.000	0.000	0.194	0.185	0.866	0.322	0.000
profit	0.008	0.000	0.000	0.211	0.032	0.027	0.359	0.064	0.000	0.000	1.000	-0.025	0.069	0.009	0.000	0.469
reliability	-0.119	0.189	0.726	0.242	0.180	0.222	0.117	0.402	0.103	0.194	-0.025	1.000	0.548	0.197	0.269	0.119
shipment mode	0.218	0.210	0.535	0.175	0.235	0.233	0.038	0.361	0.069	0.185	0.069	0.548	1.000	0.194	0.366	0.000
sub classification	0.113	0.647	0.310	0.467	0.825	0.207	0.033	0.394	0.018	0.866	0.009	0.197	0.194	1.000	0.284	0.000
vendor inco term	0.209	0.443	0.441	0.278	0.288	0.309	0.019	1.000	0.105	0.322	0.000	0.269	0.366	0.284	1.000	0.025
weight	-0.016	0.000	0.000	0.186	0.000	0.000	0.706	0.000	0.000	0.000	0.469	0.119	0.000	0.000	0.025	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	project code	country	managed by	fulfill via	vendor inco term	shipment mode	product group	sub classification	vendor	molecule/test type	brand	dosage	dosage form	manufacturing site	first line designation	freight cost (usd)	reliability	weight	profit
0	100-CI-T01	Côte d'Ivoire	PMO - US	Direct Drop	EXW	Air	HRDT	HIV test	RANBAXY Fine Chemicals LTD.	HIV, Reveal G3 Rapid HIV-1 Antibody Test	Reveal	0.0	Test kit	Ranbaxy Fine Chemicals LTD	True	780.340	40	13.0	25919.040
1	108-VN-T01	Vietnam	PMO - US	Direct Drop	EXW	Air	ARV	Pediatric	Aurobindo Pharma Limited	Nevirapine	Generic	10.0	Oral suspension	Aurobindo Unit III, India	True	4521.500	166	358.0	291648.000
2	100-CI-T01	Côte d'Ivoire	PMO - US	Direct Drop	FCA	Air	HRDT	HIV test	Abbott GmbH & Co. KG	HIV 1/2, Determine Complete HIV Kit	Determine	0.0	Test kit	ABBVIE GmbH & Co.KG Wiesbaden	True	1653.780	40	171.0	1881600.000
3	108-VN-T01	Vietnam	PMO - US	Direct Drop	EXW	Air	ARV	Adult	SUN PHARMACEUTICAL INDUSTRIES LTD (RANBAXY LABORATORIES LIMITED)	Lamivudine	Generic	150.0	Tablet	Ranbaxy, Paonta Shahib, India	True	16007.060	166	1855.0	5991052.032
4	108-VN-T01	Vietnam	PMO - US	Direct Drop	EXW	Air	ARV	Adult	Aurobindo Pharma Limited	Stavudine	Generic	30.0	Capsule	Aurobindo Unit III, India	True	45450.080	166	7590.0	5720064.000
5	112-NG-T01	Nigeria	PMO - US	Direct Drop	EXW	Air	ARV	Pediatric	Aurobindo Pharma Limited	Zidovudine	Generic	10.0	Oral solution	Aurobindo Unit III, India	True	5920.420	139	504.0	104692.224
6	110-ZM-T01	Zambia	PMO - US	Direct Drop	DDU	Air	ARV	Pediatric	MERCK SHARP & DOHME IDEA GMBH (FORMALLY MERCK SHARP & DOHME B.V.)	Efavirenz	Stocrin/Sustiva	200.0	Capsule	MSD South Granville Australia	True	6066.415	260	328.0	205752.960
7	109-TZ-T01	Tanzania	PMO - US	Direct Drop	EXW	Air	ARV	Adult	Aurobindo Pharma Limited	Nevirapine	Generic	200.0	Tablet	Aurobindo Unit III, India	True	6212.410	135	1478.0	2861657.232
8	112-NG-T01	Nigeria	PMO - US	Direct Drop	EXW	Air	ARV	Adult	Aurobindo Pharma Limited	Stavudine	Generic	30.0	Capsule	Aurobindo Unit III, India	False	8051.680	139	1060.5	25041.744
9	110-ZM-T01	Zambia	PMO - US	Direct Drop	CIP	Air	ARV	Adult	ABBVIE LOGISTICS (FORMERLY ABBOTT LOGISTICS BV)	Lopinavir/Ritonavir	Aluvia	200.0	Tablet	ABBVIE (Abbott) St. P'burg USA	True	9890.950	260	643.0	5413363.200

	project code	country	managed by	fulfill via	vendor inco term	shipment mode	product group	sub classification	vendor	molecule/test type	brand	dosage	dosage form	manufacturing site	first line designation	freight cost (usd)	reliability	Delivery Delay Risk	weight	profit
10314	151-NG-T30	Nigeria	PMO - US	From RDC	N/A - From RDC	Air Charter	ARV	Pediatric	SCMS from RDC	Lamivudine/Nevirapine/Zidovudine	Generic	30.0	Chewable/dispersible tablet - FDC	Mylan (formerly Matrix) Nashik	False	21701.144	628	-1.000000	12609.000000	1.424562e+06
10315	151-NG-T30	Nigeria	PMO - US	From RDC	N/A - From RDC	Air Charter	ARV	Adult	SCMS from RDC	Lopinavir/Ritonavir	Aluvia	200.0	Tablet	ABBVIE Ludwigshafen Germany	True	26180.000	628	-1.000000	15198.000000	1.750167e+09
10316	151-NG-T30	Nigeria	PMO - US	From RDC	N/A - From RDC	Air Charter	ARV	Adult	SCMS from RDC	Lamivudine/Zidovudine	Generic	150.0	Tablet - FDC	Aurobindo Unit III, India	True	3410.000	628	-1.000000	1547.000000	1.125776e+07
10317	151-NG-T30	Nigeria	PMO - US	From RDC	N/A - From RDC	Air	ARV	Adult	SCMS from RDC	Efavirenz	Generic	600.0	Tablet	Strides, Bangalore, India.	False	3410.000	628	-0.999329	1521.166667	5.179685e+05
10318	103-ZW-T30	Zimbabwe	PMO - US	From RDC	N/A - From RDC	Truck	ARV	Pediatric	SCMS from RDC	Lamivudine/Nevirapine/Zidovudine	Generic	30.0	Chewable/dispersible tablet - FDC	Cipla, Goa, India	False	3410.000	101	-1.000000	1495.333333	6.425699e+08
10319	103-ZW-T30	Zimbabwe	PMO - US	From RDC	N/A - From RDC	Truck	ARV	Pediatric	SCMS from RDC	Lamivudine/Nevirapine/Zidovudine	Generic	30.0	Chewable/dispersible tablet - FDC	Mylan, H-12 & H-13, India	False	3410.000	101	-1.000000	1469.500000	4.232309e+08
10320	104-CI-T30	Côte d'Ivoire	PMO - US	From RDC	N/A - From RDC	Truck	ARV	Adult	SCMS from RDC	Lamivudine/Zidovudine	Generic	150.0	Tablet - FDC	Hetero Unit III Hyderabad IN	False	3410.000	729	0.995055	1443.666667	2.221725e+07
10321	110-ZM-T30	Zambia	PMO - US	From RDC	N/A - From RDC	Truck	ARV	Adult	SCMS from RDC	Efavirenz/Lamivudine/Tenofovir Disoproxil Fumarate	Generic	600.0	Tablet - FDC	Cipla Ltd A-42 MIDC Mahar. IN	False	3410.000	406	-0.995055	1417.833333	2.716057e+10
10322	200-ZW-T30	Zimbabwe	PMO - US	From RDC	N/A - From RDC	Truck	ARV	Adult	SCMS from RDC	Lamivudine/Zidovudine	Generic	150.0	Tablet - FDC	Mylan (formerly Matrix) Nashik	True	3410.000	28	-1.000000	1392.000000	1.526224e+07
10323	103-ZW-T30	Zimbabwe	PMO - US	From RDC	N/A - From RDC	Truck	ARV	Pediatric	SCMS from RDC	Lamivudine/Zidovudine	Generic	30.0	Chewable/dispersible tablet - FDC	Cipla, Goa, India	False	3410.000	101	-1.000000	1392.000000	6.257274e+06

Most frequently occurring

	project code	country	managed by	fulfill via	vendor inco term	shipment mode	product group	sub classification	vendor	molecule/test type	brand	dosage	dosage form	manufacturing site	first line designation	freight cost (usd)	reliability	Delivery Delay Risk	weight	profit	# duplicates
4	107-RW-T30	Rwanda	PMO - US	Direct Drop	EXW	Air	HRDT	HIV test	SHANGHAI KEHUA BIOENGINEERING CO.,LTD. (KHB)	HIV 1/2, Colloidal Gold, Diagnostic Kit, Antibody	Colloidal Gold	0.0	Test kit	KHB Test Kit Facility, Shanghai China	True	26266.34	340	0.000000	1992.0	6.629535e+06	5
0	100-CI-T01	Côte d'Ivoire	PMO - US	From RDC	N/A - From RDC	Air	ARV	Adult	SCMS from RDC	Lamivudine/Nevirapine/Stavudine	Generic	150.0	Tablet - FDC	Cipla, Goa, India	True	3166.00	40	0.000000	974.0	3.175200e+06	3
16	133-NG-T30	Nigeria	PMO - US	Direct Drop	EXW	Air	HRDT	HIV test	Orgenics, Ltd	HIV 1/2, Determine Complete HIV Kit	Determine	0.0	Test kit	Alere Medical Co., Ltd.	True	24927.19	145	-0.462117	1186.0	8.361712e+07	3
19	133-NG-T30	Nigeria	PMO - US	Direct Drop	EXW	Air	HRDT	HIV test	Orgenics, Ltd	HIV 1/2, Determine Complete HIV Kit	Determine	0.0	Test kit	Alere Medical Co., Ltd.	True	28734.43	145	-0.462117	1303.0	8.361712e+07	3
1	101-CD-T30	Congo, DRC	PMO - US	From RDC	N/A - From RDC	Air	ARV	Adult	SCMS from RDC	Lamivudine	Generic	150.0	Tablet	Hetero Unit III Hyderabad IN	True	522.42	308	0.000000	1.0	4.287200e+00	2
2	102-BW-T01	Botswana	PMO - US	Direct Drop	EXW	Air	HRDT	HIV test	Trinity Biotech, Plc	HIV 1/2, Uni-Gold HIV Kit	Uni-Gold	0.0	Test kit	Trinity Biotech, Plc	True	2442.32	30	0.000000	500.0	4.096000e+05	2
3	104-CI-T01	Côte d'Ivoire	PMO - US	From RDC	N/A - From RDC	Air	ARV	Pediatric	SCMS from RDC	Nevirapine	Generic	10.0	Oral suspension	Aurobindo Unit III, India	True	1301.00	314	0.000000	170.0	1.331520e+03	2
5	107-RW-T30	Rwanda	PMO - US	Direct Drop	EXW	Air	HRDT	HIV test	SHANGHAI KEHUA BIOENGINEERING CO.,LTD. (KHB)	HIV 1/2, Colloidal Gold, Diagnostic Kit, Antibody	Colloidal Gold	0.0	Test kit	KHB Test Kit Facility, Shanghai China	True	53062.21	340	0.000000	3996.0	2.216893e+07	2
6	108-VN-T01	Vietnam	PMO - US	Direct Drop	FCA	Air	ARV	Adult	ABBVIE LOGISTICS (FORMERLY ABBOTT LOGISTICS BV)	Lopinavir/Ritonavir	Aluvia	200.0	Tablet	ABBVIE Ludwigshafen Germany	True	1767.38	166	0.000000	117.0	2.701996e+06	2
7	108-VN-T30	Vietnam	PMO - US	Direct Drop	EXW	Air	ARV	Adult	HETERO LABS LIMITED	Efavirenz/Lamivudine/Tenofovir Disoproxil Fumarate	Generic	600.0	Tablet - FDC	Hetero Unit III Hyderabad IN	True	3809.94	522	0.000000	2516.0	3.712550e+07	2

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters